Use the Name edit box to enter a name for the new key and then select a table field to include in the key from the Field(s) Name group.
Use the Reference Schema and Reference Table dropdown lists to select a foreign schema and table respectively.
To include field(s) to the key, just simply click the Field(s) Name/Foreign
Field(s) Name field or click to open the
editor(s) for editing.
The On Delete and On Update dropdown list define the type of the actions to be taken.
No Action
The Database Engine raises an error and the delete or update action on the row in the parent table is rolled back.Cascade
Corresponding rows are deleted from or updated in the referencing table if that row is deleted from or updated in the parent table.Set Null
All the values that make up the foreign key are set to NULL when the corresponding row in the parent table is deleted or updated.Set Default
All the values that make up the foreign key are set to their default values when the corresponding row in the parent table is deleted or updated.
Enable
You can choose whether to enable / disable the foreign key constraint by checking / unchecking the box.
Not for Replication
The constraint is not enforced when replication agents perform insert, update, or delete operations.
Note: SQL Azure does not support.
Comment
Specify the comment of the foreign key.
Note: SQL Azure does not support.